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