UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxQRMrzf4aNvyqaFtKc0TDx5iRycQn1PS1fzqKOUfco='
WHERE
key_id = '7889cf6931bf6d7751e2f0e004c042e5e0952cdc23de6f1164ff931472f936a3'
AND (
token = 'nxQRMrzf4aNvyqaFtKc0TDx5iRycQn1PS1fzqKOUfco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)