UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5JVQp4kdZQ8tWMA4AdXMXK0V53nnMl9VJxu+b7QpWFY='
WHERE
key_id = 'e9bb1127da28a78b8176de7d8580d0610679f2322731413398184e1af8580461'
AND (
token = '5JVQp4kdZQ8tWMA4AdXMXK0V53nnMl9VJxu+b7QpWFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)