UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MerbDgxokG4dA9vQ0xx/TqR9q93yxG6MuLjypjR44hs='
WHERE
key_id = 'ef4c4919dfa2161d82e51cbd8ce5f7efe99ae05b3c210bb3bd7ff11a8983f01c'
AND (
token = 'MerbDgxokG4dA9vQ0xx/TqR9q93yxG6MuLjypjR44hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)