UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTeRguTyLok8jVtEmvWnme5buA6OhXKX6fK9GyaOHz4='
WHERE
key_id = '97f672796d4d116fa7e6670399ca3fd4c1711bfe8473f0774310498fa27a28c9'
AND (
token = 'LTeRguTyLok8jVtEmvWnme5buA6OhXKX6fK9GyaOHz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)