UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jvZtG1jy/R4dq1xkYkr+4vnceWwDlCu4253KBYdzjyk='
WHERE
key_id = 'd4fd72cf69ff98023a19744be57e5f770bc0c099fb66a59b9308486939479b46'
AND (
token = 'jvZtG1jy/R4dq1xkYkr+4vnceWwDlCu4253KBYdzjyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)