UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIt3A48eVUIqrd9scOLssDLtKt6TPqlT8sqeHBsrVsU='
WHERE
key_id = '905b2b3ceac7d68d723158a7defc3aa693fa0eee82c6c7860c832a14fbb38b57'
AND (
token = 'BIt3A48eVUIqrd9scOLssDLtKt6TPqlT8sqeHBsrVsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)