UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTWFRVpJv+1X7b4NPPCDF1FtCqhtAjtIME6ZkZ4IqME='
WHERE
key_id = '1978aff4ceda302ab7c7bf7f3d92917f2e6ae8ce76009ac30c063047ad7e1348'
AND (
token = 'LTWFRVpJv+1X7b4NPPCDF1FtCqhtAjtIME6ZkZ4IqME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)