UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hkLaStz0sx7V32i6iK3uM4cMAFcucyzgOSVaYUjzgW0='
WHERE
key_id = '99e562cc29b72003e89ef45415f532652897d5ea6b1b7b42a792b53914b13f69'
AND (
token = 'hkLaStz0sx7V32i6iK3uM4cMAFcucyzgOSVaYUjzgW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)