UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oi3iOhKDDf8H90IBA9dCSKmY265TmHwNr/lYKW40EIM='
WHERE
key_id = 'a398c5a5335188bd9a5598cd33302be62e5e4da0637379d874a2656b99444d6b'
AND (
token = 'oi3iOhKDDf8H90IBA9dCSKmY265TmHwNr/lYKW40EIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)