UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WrHo3/mZ3ysDSuQOrEWArNWViTfeXitliVCNKmVdILM='
WHERE
key_id = 'ce124a8fbc9f76ab6c7663c345da31897680ee1bde53999af9dadc853b17adcc'
AND (
token = 'WrHo3/mZ3ysDSuQOrEWArNWViTfeXitliVCNKmVdILM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)