UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZX0i8Jmzut5DDxsOWY0nB3AQL9dQY9uirMnveHtyay8='
WHERE
key_id = '866ab7a02625a4700a88cab4029a3a87f176b2c32dacff036cd746c04f947b21'
AND (
token = 'ZX0i8Jmzut5DDxsOWY0nB3AQL9dQY9uirMnveHtyay8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)