UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8o5f7zAuGiUO08quKHAyrngJ+U0xTpwZ0l1b1sA3dc='
WHERE
key_id = 'a47bd01493318ec9c2737ba44d63e892ce7b4522799566804b0b1c6943cd2ab1'
AND (
token = 'k8o5f7zAuGiUO08quKHAyrngJ+U0xTpwZ0l1b1sA3dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)