UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+NAsD/QUTRxljBa7BmXG8tYc4dW42ad/RWJdYWbvn8='
WHERE
key_id = '0e7847114f3cdd8b82844660ce96cd981800a96dac6bae4c6e8e3fe8d37fb7c1'
AND (
token = 'r+NAsD/QUTRxljBa7BmXG8tYc4dW42ad/RWJdYWbvn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)