UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0x8E3W6PaSJEwNKe1w4VFoBnXw6ro0TX0uf3tYxO+F8='
WHERE
key_id = '1ac6379e38a458d78147207c63bb8c69eb8a714435a9e58ac56ee767e90d9f43'
AND (
token = '0x8E3W6PaSJEwNKe1w4VFoBnXw6ro0TX0uf3tYxO+F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)