UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nOOX8cCNufQGL2YWBFk3y9fn9qTSmmT/0c89nevxVgE='
WHERE
key_id = '1cac65361c549a8821d4ec46532eb43f9779572eab11da62b257e2f7b55433e3'
AND (
token = 'nOOX8cCNufQGL2YWBFk3y9fn9qTSmmT/0c89nevxVgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)