UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RWRN0IGf0CEaRYQZLhUjKP5qCDvjRuUtb+YR1FDDLNw='
WHERE
key_id = '047e1eff0ebe9ed52c0214518735aefbb6a7b07482e03a7894724e6b659cd97c'
AND (
token = 'RWRN0IGf0CEaRYQZLhUjKP5qCDvjRuUtb+YR1FDDLNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)