UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmzBjxGZrP7L3FXNgfUbnBd0LDC4dqckvg/FIimjLWs='
WHERE
key_id = '1ba7dc36c84f6bb954361cd9a3f065017252087ca0021de6db3057f33b23dfc4'
AND (
token = 'pmzBjxGZrP7L3FXNgfUbnBd0LDC4dqckvg/FIimjLWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)