UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KXbSHsGOI84txPrFPm0MQ6UB0xv4onUe6W/0C6sIHY='
WHERE
key_id = 'c6d6b13f1cfb05f2bf1fd796ea289c53ba12fdda4286a8480a9c6c653ea2b5ce'
AND (
token = '4KXbSHsGOI84txPrFPm0MQ6UB0xv4onUe6W/0C6sIHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)