UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0IWRNWsMSaEHir8sgeSzf/L927rPBJfxz8e7CRgiv0='
WHERE
key_id = '8cef9455851c61d6690322f62ac9315fa16c240e1c698e8e90d5a48d0c790555'
AND (
token = 'u0IWRNWsMSaEHir8sgeSzf/L927rPBJfxz8e7CRgiv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)