UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BT7fx8mdofl/dxHT30BwlIGht734sfBVLaXEW32P1ss='
WHERE
key_id = '49d4eacecf35c4f385438fece3bc68aa1869dd0875883c7c34fbfcd8db2ed037'
AND (
token = 'BT7fx8mdofl/dxHT30BwlIGht734sfBVLaXEW32P1ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)