UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3DhVRXT9otj/cS0DmD8yCe1noh+xp4jvebnGCAadKjM='
WHERE
key_id = 'c9f0867f9a5f6c258cfc911041688c66d29e92f1cc77b62483a8d0f9620e87e4'
AND (
token = '3DhVRXT9otj/cS0DmD8yCe1noh+xp4jvebnGCAadKjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)