UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcPgjyeujCY0eKFVdSAdn0kvTfW3cnJtXq1uJSQm2HI='
WHERE
key_id = '8b3a74f5811e9d747f3138bbb2db9a7f8db67520d5de3c80c310a6bbd96762c3'
AND (
token = 'zcPgjyeujCY0eKFVdSAdn0kvTfW3cnJtXq1uJSQm2HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)