UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lirwjrVZ8SIg3iMxcATa6RzUqXobADMjgFgW/EqYiF4='
WHERE
key_id = 'c4fe44d980a364216e330a6b044b700086accce66b591159df97b08817267cf4'
AND (
token = 'lirwjrVZ8SIg3iMxcATa6RzUqXobADMjgFgW/EqYiF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)