UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcbVOfUMAXcCllCrUlDW9oQR2DBqE3PtlsEsK+k6zGs='
WHERE
key_id = '03e8cc2d820a58b2c35eeeaaf99fd8c578ae751e68c575746d5424a075239569'
AND (
token = 'ZcbVOfUMAXcCllCrUlDW9oQR2DBqE3PtlsEsK+k6zGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)