UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MsUC3nUxfHz2sPfYtLwbLwyoe5dP1gmGCFxda2D898U='
WHERE
key_id = '4b687c3436b0d7ee72868e6b20afa026113a5f254815ba3b4ed1f69e40b3616a'
AND (
token = 'MsUC3nUxfHz2sPfYtLwbLwyoe5dP1gmGCFxda2D898U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)