UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N2ln8B68LGsX+9nhRg7eyUCFj9lnuqEzu13/vo2xhG0='
WHERE
key_id = '27d8972e411955e1664d39fa783662a85997a8450e356da5bc11cad0e45dd5f6'
AND (
token = 'N2ln8B68LGsX+9nhRg7eyUCFj9lnuqEzu13/vo2xhG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)