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