UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2D8G3p2YPDyjBFEbLWzuB1LZIvTG8gpAlewNORc6GK0='
WHERE
key_id = 'd440ca0e0992dd6263509e0b41182b3b95d79dc76e526e5c8f8f6772866b0aeb'
AND (
token = '2D8G3p2YPDyjBFEbLWzuB1LZIvTG8gpAlewNORc6GK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)