UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccaeoy7k2oR8S0iBTWizQIF1glFoEYuqR1Q/NpZSg/s='
WHERE
key_id = '8abe29299d7708b7f2efafaf29351f0f65d4f1227351d3feedefcb67b76f2747'
AND (
token = 'ccaeoy7k2oR8S0iBTWizQIF1glFoEYuqR1Q/NpZSg/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)