UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGpqwSjOuWXZQTF6e54+4IwBxI/gZAjDeMoqrFzbkfE='
WHERE
key_id = '0ffd4e5ec974ff117835bc00893608eb32bd167800e8c76f6cf011f98397fb78'
AND (
token = 'nGpqwSjOuWXZQTF6e54+4IwBxI/gZAjDeMoqrFzbkfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)