UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJIF+fv9rMpE9zPiZgCI9FXxJI8B7I6vSnqjkBZWcVU='
WHERE
key_id = 'ae3cf5679e550d4d8c1b9b04547e1687e3ffc053026e7c12ed993a8640d23feb'
AND (
token = 'DJIF+fv9rMpE9zPiZgCI9FXxJI8B7I6vSnqjkBZWcVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)