UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zL6Avn6mqJxjY2c0Grt1hqRjktcFXIFu4ZsU11+Heh0='
WHERE
key_id = 'e875ba1106f0052aab891f7dc9cfcad563a90ca6941647c9874d6fc8ff23e7e7'
AND (
token = 'zL6Avn6mqJxjY2c0Grt1hqRjktcFXIFu4ZsU11+Heh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)