UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nV6ZVvr5y4Vmy4ZRvdtXMVjAIsdw/vA60JF2Mk8J0m0='
WHERE
key_id = '8b783eeaab6ea974da1994fdc81cb15a3cba0e14024f37182b019f8a875bbb5a'
AND (
token = 'nV6ZVvr5y4Vmy4ZRvdtXMVjAIsdw/vA60JF2Mk8J0m0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)