UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNp9GVpT3GIywury5ffgwPwGr98Hf6jrX+oheUYuU74='
WHERE
key_id = '5b877dcae5dd45f6bc55343a3c97ad05e6d7efa27bd6c04e5fad2e8da331935f'
AND (
token = 'pNp9GVpT3GIywury5ffgwPwGr98Hf6jrX+oheUYuU74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)