UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CafeJITo7GTVXzRI0thtwjRWYhcPohvb2AKLll4nniM='
WHERE
key_id = 'a9880ca70547ff1dbebd6ce877971ed7398e201e4d2882267fa492bab93aeabe'
AND (
token = 'CafeJITo7GTVXzRI0thtwjRWYhcPohvb2AKLll4nniM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)