UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ymVZEJ3j4kQOSQPkmQ/3TF7aXLxWeQBudOlONv8yWa4='
WHERE
key_id = 'e653c2dde2560f1af6d37a3e4fc77c22bcf71a2b149cd45b8ff3d30b2188ee63'
AND (
token = 'ymVZEJ3j4kQOSQPkmQ/3TF7aXLxWeQBudOlONv8yWa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)