UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U5kUAbY1TVQnceU1bVUt3y+2NHCt7nwLsXBL9sJJnr0='
WHERE
key_id = 'a52db3cd684e1448e583fd4097b22600ea7b62b4a781d5fc5f75e4df372ba4bd'
AND (
token = 'U5kUAbY1TVQnceU1bVUt3y+2NHCt7nwLsXBL9sJJnr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)