UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pMSmVilLq3pTgmSrBnJ1hLU6MNFsdQcly+TP+HHjxHc='
WHERE
key_id = '1d322689e2b102593820a0a5595b13139d0aebffdb364e44bf0a54ff39657668'
AND (
token = 'pMSmVilLq3pTgmSrBnJ1hLU6MNFsdQcly+TP+HHjxHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)