UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgX22XQH8b7w5aVkwheVlXM95g0feHsBTsW1S17W/Uc='
WHERE
key_id = '16f06ef4e98272e1fd7108b731cd8fee1478357be8c5a9fcdd6f1a79cf874942'
AND (
token = 'zgX22XQH8b7w5aVkwheVlXM95g0feHsBTsW1S17W/Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)