UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6kcISPThIKEXMropphpHgwur/nWdL/SjDNvkh3mp4VE='
WHERE
key_id = 'cbcb679cc3c2e93da04aed50f8f1e4a6a2b4c4c242bc51ee763af04f5785e467'
AND (
token = '6kcISPThIKEXMropphpHgwur/nWdL/SjDNvkh3mp4VE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)