UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXak9VQmSVG3EeKNAXxRwjDMWO95IuagwGw8tvZAXlM='
WHERE
key_id = 'd2c480082c0856f7eb053edd38aa678897c37f98837cbd3f7f34d13d278f99d3'
AND (
token = 'bXak9VQmSVG3EeKNAXxRwjDMWO95IuagwGw8tvZAXlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)