UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHMw5Hqcf0QqtzzHIie0sXp1SlANQFWG7n0PNb4aDAU='
WHERE
key_id = 'bf930059139c91c94fd49e5eb5b8257d1ebfdd507d96f086f7fb19f2fbf4db29'
AND (
token = 'tHMw5Hqcf0QqtzzHIie0sXp1SlANQFWG7n0PNb4aDAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)