UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whz+zQHTEQaSMUL1zaviJsP58RmtqKZz+E+dnx37+Zs='
WHERE
key_id = 'e04cb9c990989d6a0de32c534ae8adf6af2cab02b1f208a9de4ec395bce1118c'
AND (
token = 'whz+zQHTEQaSMUL1zaviJsP58RmtqKZz+E+dnx37+Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)