UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A72I2/pD8ClTA2AnSJGZNT70JBFyf9n8JPKdU5mwxGs='
WHERE
key_id = '99424664bfc5c37b41508e0f75362f621612e06101ea1266d3bf387c03f53c42'
AND (
token = 'A72I2/pD8ClTA2AnSJGZNT70JBFyf9n8JPKdU5mwxGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)