UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4sIyJ/80gXiPx+lMVKOCJjfT//tOsdQVU0E1If4vlZI='
WHERE
key_id = 'c1a4d547205a49406bf4caaa5c896123b1a77e3c426fa1f8433eaf00485cf6fa'
AND (
token = '4sIyJ/80gXiPx+lMVKOCJjfT//tOsdQVU0E1If4vlZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)