UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+X+ysIygq7uHofw0P2/I14i3/q3Y58mlbxC61OsBM+o='
WHERE
key_id = '417531d0c61bbae316192e619304807912040cc8006b01ab01a665ebcffb5165'
AND (
token = '+X+ysIygq7uHofw0P2/I14i3/q3Y58mlbxC61OsBM+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)