UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0auLGbj7KfY5NUgX0oFIr4+AC9DPL4nkjof2dlvc2k8='
WHERE
key_id = '3d9bf0e68fa06378cd3d4afc8ddce4f0361f6d6999b53aee3b92a73df535f7e3'
AND (
token = '0auLGbj7KfY5NUgX0oFIr4+AC9DPL4nkjof2dlvc2k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)