UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cj9fVNxNbWdMGp4N0tPjSod08PxvdTnG5h2Qhw+T3Bs='
WHERE
key_id = '3f527aa687749e98be2fe617f91a75d3bb3d2f0f6190f1eb22aa057304891189'
AND (
token = 'Cj9fVNxNbWdMGp4N0tPjSod08PxvdTnG5h2Qhw+T3Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)