UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkCA0w7dSGM1p3cWzvcwB5XKDMx+pbV2kMSIG+cEp7o='
WHERE
key_id = 'a32d520c2027fc83b32fc5b02ad56ee835454cece31997919969a5765ca82790'
AND (
token = 'bkCA0w7dSGM1p3cWzvcwB5XKDMx+pbV2kMSIG+cEp7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)