UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XODbyK/R6tO/qrGVAtHEk2blP8i4NnaVwcb9lggVwSI='
WHERE
key_id = 'c9cbc5a972432ee657844d5b628ec5a98f594d13053c14a97f27894642d73975'
AND (
token = 'XODbyK/R6tO/qrGVAtHEk2blP8i4NnaVwcb9lggVwSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)